Questions
20 of 25
1How do you define a TypeORM entity and register it in a NestJS feature module?
2How do you handle TypeORM migrations in a NestJS project?
3How do you run a transaction with Prisma in NestJS?
4How do you perform CRUD operations and add query methods to a Mongoose model in NestJS?
5How do you use Prisma with multiple databases in a single NestJS application?
6What is the difference between find(), findOne(), findOneOrFail(), and the Query Builder in TypeORM?
7What are the two main ways to run a database transaction in TypeORM with NestJS?
8How do you handle Prisma migrations in a CI/CD pipeline?
9How do you add schema middleware (hooks) and instance methods in NestJS Mongoose?
10How do you mock a repository in a NestJS unit test?
11How do you seed a database in a NestJS application?
12How do you implement a Unit of Work pattern to group database operations across repositories in NestJS?
13How do you implement optimistic locking with TypeORM to prevent lost updates in NestJS?
14How do you integrate Prisma into a NestJS application?
15How do you implement soft deletes in NestJS with TypeORM?
16How do you implement multi-tenancy with a shared database in NestJS TypeORM?
17How do you set up TypeORM in a NestJS application?
18How do you implement a custom TypeORM repository in NestJS?
19How do you propagate a TypeORM transaction across multiple services in NestJS?
20What are Prisma middleware and how do you use them for audit logging in NestJS?
21How do you set up Mongoose in a NestJS application and define a schema?
22How do you handle Mongoose transactions for multi-document atomic operations in NestJS?
23What is the repository pattern and why use it in NestJS?
24How do you handle database connection pooling and health checks in NestJS?
25How do you implement database read replicas in NestJS for read/write splitting with TypeORM?
20 / 25

What are Prisma middleware and how do you use them for audit logging in NestJS?

Prisma middleware are functions registered with $use() that intercept every query before and after execution. They receive params (model, action, args) and a next function. Use them for audit logging on write operations, global soft-delete filters, query performance monitoring, and cross-cutting data transformations.

Audit logging and soft-delete middleware
Prisma middleware design notes:
  1. 1

    Middleware is registered with $use() before $connect() — order of registration determines execution order.

  2. 2

    params.model is the model name (e.g. 'User'); params.action is the operation (e.g. 'create', 'findMany').

  3. 3

    Always call and return await next(params) — omitting it prevents the query from executing.

  4. 4

    Middleware runs for every query including those inside $transaction() callbacks.

  5. 5

    Prisma 5+ deprecates $use() in favor of Prisma Client Extensions — plan migrations accordingly.